﻿CREATE PROCEDURE [acms].[Site_GetByRootUrl]
	@RootUrl varchar(255)
AS
	SELECT *
	FROM [acms].[Site_View]
	WHERE Root = @RootUrl
	
	RETURN 0;